This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.
When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Cmd+Shift+K to preview the HTML file).
The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.
You can write HTML and embed a Google Form
Load packages
library(gsheet)
library(tidyverse)
library(quanteda)
library(ggplot2)
library(plotly)
Read data and inspect
url <- "https://docs.google.com/spreadsheets/d/1qmbPdvspf9Vg_Eab9fT34ubudF_vklJwKxf0UuJrHvw/edit?usp=sharing"
rawDF <- gsheet2tbl(url)
colVec <- c("time", "github", "languages", "proficiency")
colnames(rawDF) <- colVec
summary(rawDF)
time github languages proficiency
Length:2 Length:2 Length:2 Min. :3.00
Class :character Class :character Class :character 1st Qu.:3.25
Mode :character Mode :character Mode :character Median :3.50
Mean :3.50
3rd Qu.:3.75
Max. :4.00
head(rawDF)
Count languages
languages <- as.character(rawDF$languages) %>% corpus
summary(languages)
Corpus consisting of 2 documents, showing 2 documents:
Text Types Tokens Sentences
text1 6 9 1
text2 3 3 1
dfm <- tokens(languages) %>%
dfm %>% convert(to="data.frame") %>%
select(!contains(",")) %>%
summarise(across(where(is.numeric), ~ sum(.x, na.rm = TRUE))) %>%
pivot_longer(everything(), names_to = "language", values_to = "count")
dfm
Create plots
Simple
proficiency <- table(rawDF$proficiency)
barplot(proficiency,
xlab="Proficiency Score", ylab="Score Count")

Styled
p1 <- ggplot(dfm) +
aes(x=language, y=count, fill=language) +
geom_col()
p1

LS0tCnRpdGxlOiAiSGVsbG8gWW91ISIKb3V0cHV0OiBodG1sX25vdGVib29rCi0tLQoKVGhpcyBpcyBhbiBbUiBNYXJrZG93bl0oaHR0cDovL3JtYXJrZG93bi5yc3R1ZGlvLmNvbSkgTm90ZWJvb2suIFdoZW4geW91IGV4ZWN1dGUgY29kZSB3aXRoaW4gdGhlIG5vdGVib29rLCB0aGUgcmVzdWx0cyBhcHBlYXIgYmVuZWF0aCB0aGUgY29kZS4gCgpXaGVuIHlvdSBzYXZlIHRoZSBub3RlYm9vaywgYW4gSFRNTCBmaWxlIGNvbnRhaW5pbmcgdGhlIGNvZGUgYW5kIG91dHB1dCB3aWxsIGJlIHNhdmVkIGFsb25nc2lkZSBpdCAoY2xpY2sgdGhlICpQcmV2aWV3KiBidXR0b24gb3IgcHJlc3MgKkNtZCtTaGlmdCtLKiB0byBwcmV2aWV3IHRoZSBIVE1MIGZpbGUpLiAKClRoZSBwcmV2aWV3IHNob3dzIHlvdSBhIHJlbmRlcmVkIEhUTUwgY29weSBvZiB0aGUgY29udGVudHMgb2YgdGhlIGVkaXRvci4gQ29uc2VxdWVudGx5LCB1bmxpa2UgKktuaXQqLCAqUHJldmlldyogZG9lcyBub3QgcnVuIGFueSBSIGNvZGUgY2h1bmtzLiBJbnN0ZWFkLCB0aGUgb3V0cHV0IG9mIHRoZSBjaHVuayB3aGVuIGl0IHdhcyBsYXN0IHJ1biBpbiB0aGUgZWRpdG9yIGlzIGRpc3BsYXllZC4KCjxwPllvdSBjYW4gd3JpdGUgSFRNTCBhbmQgZW1iZWQgYSBHb29nbGUgRm9ybTwvcD4KCjxpZnJhbWUgc3JjPSJodHRwczovL2RvY3MuZ29vZ2xlLmNvbS9mb3Jtcy9kL2UvMUZBSXBRTFNkOUkzbDBJWDNhWFViN19UX0VkN09HTzZWY1BwSS1EUGRsV25mTVQxcTJYX25aRncvdmlld2Zvcm0/ZW1iZWRkZWQ9dHJ1ZSIgd2lkdGg9IjY0MCIgaGVpZ2h0PSIxNDUyIiBmcmFtZWJvcmRlcj0iMCIgbWFyZ2luaGVpZ2h0PSIwIiBtYXJnaW53aWR0aD0iMCI+TG9hZGluZ+KApjwvaWZyYW1lPgoKIyMgTG9hZCBwYWNrYWdlcwoKYGBge3J9CmxpYnJhcnkoZ3NoZWV0KQpsaWJyYXJ5KHRpZHl2ZXJzZSkKbGlicmFyeShxdWFudGVkYSkKbGlicmFyeShnZ3Bsb3QyKQpsaWJyYXJ5KHBsb3RseSkKYGBgCgoKIyMgUmVhZCBkYXRhIGFuZCBpbnNwZWN0CgpgYGB7cn0KdXJsIDwtICJodHRwczovL2RvY3MuZ29vZ2xlLmNvbS9zcHJlYWRzaGVldHMvZC8xcW1iUGR2c3BmOVZnX0VhYjlmVDM0dWJ1ZEZfdmtsSndLeGYwVXVKckh2dy9lZGl0P3VzcD1zaGFyaW5nIgoKcmF3REYgPC0gZ3NoZWV0MnRibCh1cmwpCgpjb2xWZWMgPC0gYygidGltZSIsICJnaXRodWIiLCAibGFuZ3VhZ2VzIiwgInByb2ZpY2llbmN5IikKY29sbmFtZXMocmF3REYpIDwtIGNvbFZlYwpzdW1tYXJ5KHJhd0RGKQpoZWFkKHJhd0RGKQpgYGAKCiMjIENvdW50IGxhbmd1YWdlcwoKYGBge3J9Cmxhbmd1YWdlcyA8LSBhcy5jaGFyYWN0ZXIocmF3REYkbGFuZ3VhZ2VzKSAlPiUgY29ycHVzCnN1bW1hcnkobGFuZ3VhZ2VzKQoKZGZtIDwtIHRva2VucyhsYW5ndWFnZXMpICU+JQogIGRmbSAgJT4lIGNvbnZlcnQodG89ImRhdGEuZnJhbWUiKSAlPiUKICBzZWxlY3QoIWNvbnRhaW5zKCIsIikpICU+JQogIHN1bW1hcmlzZShhY3Jvc3Mod2hlcmUoaXMubnVtZXJpYyksIH4gc3VtKC54LCBuYS5ybSA9IFRSVUUpKSkgJT4lCiAgcGl2b3RfbG9uZ2VyKGV2ZXJ5dGhpbmcoKSwgbmFtZXNfdG8gPSAibGFuZ3VhZ2UiLCB2YWx1ZXNfdG8gPSAiY291bnQiKSAKZGZtCmBgYAoKIyMgQ3JlYXRlIHBsb3RzCgojIyMgU2ltcGxlCgpgYGB7cn0KcHJvZmljaWVuY3kgPC0gdGFibGUocmF3REYkcHJvZmljaWVuY3kpCmJhcnBsb3QocHJvZmljaWVuY3ksCiAgIHhsYWI9IlByb2ZpY2llbmN5IFNjb3JlIiwgeWxhYj0iU2NvcmUgQ291bnQiKQpgYGAKCiMjIyBTdHlsZWQKYGBge3J9CnAxIDwtIGdncGxvdChkZm0pICsKICBhZXMoeD1sYW5ndWFnZSwgeT1jb3VudCwgZmlsbD1sYW5ndWFnZSkgKwogIGdlb21fY29sKCkKcDEKYGBgCgojIyMgSW50ZXJhY3RpdmUKCmBgYHtyfQpnZ3Bsb3RseShwMSkKYGBgCgoK